USE JICCDB
GO
CREATE PROC proc_getDptName
AS
SELECT DptID,DptName,p.picture,DptMemo
FROM tab_Department as d inner join tab_Picture as p
on d.DptPhotoID = p.PicID
GO
